{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["March12nc"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"March12nc","index":0,"n_rows":40,"n_cols":36,"rows_kept":40,"cut":false,"hidden":false,"merged":[[0,0,0,26],[6,31,7,31],[6,32,7,32]]}
["March 12 Non Calculator"]
[null,"q1a","q1b","q2","q3a","q3b","q4","q5a","q5b","q6","q7","8a","8b","q9","q10","q11","q12","q13a","q13b","q14","q15","q16","q17","q18","q19","q20","q21a","q21b","q22","q23","q24"]
[null,"Collecting Like Terms ","Reverse Percentages","Estimation","Multiplication and Division","Easy Percentage + fractions Ao3 Questions","Angles in Parallel Lines","Probability ","Probability ","Averages and Range ","Stem and Leaf ","Solving Equations ","Solving Equations ","Create a Formula","Ratio ","Area AO3 Problems","Frequency Polygons","Drawing Straight Line Graphs","Solving Simultaneous Equations Graphically","Standard Form","Algebraic Assorted Questions","Box plots","Similar Shapes","Tree Diagrams","Circle Theorems","Drawing Quadratic Graphs","More Difficult Rearranging Formulae","Substitute to show a solution is correct","Surds","Vectors","Trig and Pythag AO3 Problems"]
["Max Mark",2,1,3,3,3,3,2,2,4,5,2,2,3,2,6,3,3,1,3,7,3,4,5,6,3,2,3,4,4,6]
["Class Average (%)",{"$f":"AVERAGE(B9:B40)/B4","v":1},1,0.66666666666666663,1,1,0,1,0,1,1,1,1,0,1,0,0.33333333333333331,0.33333333333333331,0,0,0.2857142857142857,0,0.5,0,0.16666666666666666,0.33333333333333331,0,{"$f":"AVERAGE(AB9:AB40)/AB4","v":0},0,0,0]
["Standard Deviation",{"$f":"IF(COUNT(B9:B36)<2,\"\",STDEV(B9:B40)/B4)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(COUNT(AB9:AB36)<2,\"\",STDEV(AB9:AB40)/AB4)","v":0},0,0,0]
[null,"q1a","q1b","q2","q3a","q3b","q4","q5a","q5b","q6","q7","8a","8b","q9","q10","q11","q12","q13a","q13b","q14","q15","q16","q17","q18","q19","q20","q21a","q21b","q22","q23","q24","Total Marks","Grade"]
["Name"]
["sample 1",2,1,2,3,3,0,2,0,4,5,2,2,0,2,0,1,1,0,0,2,0,2,0,1,1,0,0,0,0,0,{"$f":"IF(AE9=\"\",\"\",SUM(B9:AE9))","v":36},{"$f":"IF(AF9=\"\",\"\",VLOOKUP(AF9,$AI$13:$AJ$34,2))","v":"C2"}]
["sample 2",2,1,2,3,3,0,2,0,4,5,2,2,0,2,0,1,1,0,0,2,0,2,0,1,1,0,0,0,0,0,{"$f":"IF(AE10=\"\",\"\",SUM(B10:AE10))","v":36},{"$f":"IF(AF10=\"\",\"\",VLOOKUP(AF10,$AI$13:$AJ$34,2))","v":"C2"},null,"Grade Boundaries"]
["sample 3",2,1,2,3,3,0,2,0,4,5,2,2,0,2,0,1,1,0,0,2,0,2,0,1,1,0,0,0,0,0,36,"C2"]
["sample 4",2,1,2,3,3,0,2,0,4,5,2,2,0,2,0,1,1,0,0,2,0,2,0,1,1,0,0,0,0,0,36,"C2",null,"Non- Calc"]
["sample 5",2,1,2,3,3,0,2,0,4,5,2,2,0,2,0,1,1,0,0,2,0,2,0,1,1,0,0,0,0,0,36,"C2",null,0,"F3"]
["sample 6",2,1,2,3,3,0,2,0,4,5,2,2,0,2,0,1,1,0,0,2,0,2,0,1,1,0,0,0,0,0,36,"C2",null,{"$f":"AI13+(AI16-AI13)/3","v":3.6666666666666665},"F2"]
["sample 7",2,1,2,3,3,0,2,0,4,5,2,2,0,2,0,1,1,0,0,2,0,2,0,1,1,0,0,0,0,0,36,"C2",null,{"$f":"AI13+2*(AI16-AI13)/3","v":7.333333333333333},"F1"]
["sample 8",2,1,2,3,3,0,2,0,4,5,2,2,0,2,0,1,1,0,0,2,0,2,0,1,1,0,0,0,0,0,36,"C2",null,11,"E3"]
["sample 9",2,1,2,3,3,0,2,0,4,5,2,2,0,2,0,1,1,0,0,2,0,2,0,1,1,0,0,0,0,0,36,"C2",null,{"$f":"AI16+(AI19-AI16)/3","v":12.666666666666666},"E2"]
["sample 10",2,1,2,3,3,0,2,0,4,5,2,2,0,2,0,1,1,0,0,2,0,2,0,1,1,0,0,0,0,0,36,"C2",null,{"$f":"AI16+2*(AI19-AI16)/3","v":14.333333333333334},"E1"]
["sample 11",2,1,2,3,3,0,2,0,4,5,2,2,0,2,0,1,1,0,0,2,0,2,0,1,1,0,0,0,0,0,36,"C2",null,16,"D3"]
["sample 12",2,1,2,3,3,0,2,0,4,5,2,2,0,2,0,1,1,0,0,2,0,2,0,1,1,0,0,0,0,0,36,"C2",null,{"$f":"AI19+(AI22-AI19)/3","v":19.333333333333332},"D2"]
["sample 13",2,1,2,3,3,0,2,0,4,5,2,2,0,2,0,1,1,0,0,2,0,2,0,1,1,0,0,0,0,0,36,"C2",null,{"$f":"AI19+2*(AI22-AI19)/3","v":22.666666666666668},"D1"]
["sample 14",2,1,2,3,3,0,2,0,4,5,2,2,0,2,0,1,1,0,0,2,0,2,0,1,1,0,0,0,0,0,36,"C2",null,26,"C3"]
["sample 15",2,1,2,3,3,0,2,0,4,5,2,2,0,2,0,1,1,0,0,2,0,2,0,1,1,0,0,0,0,0,36,"C2",null,{"$f":"AI22+(AI25-AI22)/3","v":31.666666666666668},"C2"]
["sample 16",2,1,2,3,3,0,2,0,4,5,2,2,0,2,0,1,1,0,0,2,0,2,0,1,1,0,0,0,0,0,36,"C2",null,{"$f":"AI22+2*(AI25-AI22)/3","v":37.333333333333336},"C1"]
["sample 17",2,1,2,3,3,0,2,0,4,5,2,2,0,2,0,1,1,0,0,2,0,2,0,1,1,0,0,0,0,0,36,"C2",null,43,"B3"]
["sample 18",2,1,2,3,3,0,2,0,4,5,2,2,0,2,0,1,1,0,0,2,0,2,0,1,1,0,0,0,0,0,36,"C2",null,{"$f":"AI25+(AI28-AI25)/3","v":49},"B2"]
["sample 19",2,1,2,3,3,0,2,0,4,5,2,2,0,2,0,1,1,0,0,2,0,2,0,1,1,0,0,0,0,0,36,"C2",null,{"$f":"AI25+2*(AI28-AI25)/3","v":55},"B1"]
["sample 20",2,1,2,3,3,0,2,0,4,5,2,2,0,2,0,1,1,0,0,2,0,2,0,1,1,0,0,0,0,0,36,"C2",null,61,"A3"]
["sample 21",2,1,2,3,3,0,2,0,4,5,2,2,0,2,0,1,1,0,0,2,0,2,0,1,1,0,0,0,0,0,36,"C2",null,{"$f":"AI28+(AI31-AI28)/3","v":67.333333333333329},"A2"]
["sample 22",2,1,2,3,3,0,2,0,4,5,2,2,0,2,0,1,1,0,0,2,0,2,0,1,1,0,0,0,0,0,36,"C2",null,{"$f":"AI28+2*(AI31-AI28)/3","v":73.666666666666671},"A1"]
["sample 23",2,1,2,3,3,0,2,0,4,5,2,2,0,2,0,1,1,0,0,2,0,2,0,1,1,0,0,0,0,0,36,"C2",null,80," A*3"]
["sample 24",2,1,2,3,3,0,2,0,4,5,2,2,0,2,0,1,1,0,0,2,0,2,0,1,1,0,0,0,0,0,36,"C2",null,{"$f":"AI31+(AI34-AI31)/3","v":86.666666666666671},"A*2"]
["sample 25",2,1,2,3,3,0,2,0,4,5,2,2,0,2,0,1,1,0,0,2,0,2,0,1,1,0,0,0,0,0,36,"C2",null,{"$f":"AI31+2*(AI34-AI31)/3","v":93.333333333333329},"A*1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,100,"A*1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]